SELECT T.*,
  T_USER_GROUP.CODE AS USER_GROUP_CODE,
  T_USER_GROUP.NAME AS USER_GROUP_NAME,
  T_ORG.CODE       AS ORG_CODE,
  T_ORG.NAME       AS ORG_NAME
FROM C1_US_GROUP_ORG T
LEFT JOIN C1_USER_GROUP T_USER_GROUP
ON (T_USER_GROUP.id = t.user_group_id)
LEFT JOIN C1_ORG T_ORG
ON (T_ORG.id = t.ORG_ID)
WHERE T.id          = :id